Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | |
RetailTransactionLineItemSequenceNumber (FK)(PK) | The sequence number of line item within the context of this RetailTransaction. | IC_LN_ITM | LineNumber | smallint | |
CreditDeibitCardTypeCode | A code denoting which kind of card is being accepted. Sample values include: DEBIT CREDIT EBT FLEET OTHER | TY_CRD | Code6 | char(6) | |
CardIssuerCode | The first six digits from the Credit/Debit card. It identifies the bank or other financial institution that issued the debit/credit card used in the transaction. | ID_ISSR_TND_CRD | Code6 | char(6) | |
AccountNumber | The account number appearing on a debit/credit card and identifying the card issuer's customer account to be charged or credited for the transaction. This information must be encrypted. | ID_ACNT_DB_CR_CRD | Name | varchar(40) | |
CardEntryMethodCode | A code that indicates how the credit or debit card information was entered: Eg: swiped (MSR), tapped (contactless RFID card), near field (mobile) or manually keyed. | LU_MTH_CRD_ENR | Code2AccessControl | char(2) | |
EntrySourceCode | A code denoting who entered the card: Merchant or Customer. | LU_SCR_ENR | Code2 | char(2) | |
PersonalIDRequiredTypeCode | Identifies the type of personal identification required to authorize tender. Examples include driver's license, a second credit card, social security card, etc. | TY_ID_PRSL_RQ | Code2 | char(2) | |
PersonalIDReferenceNumber | The identifying number of the driver license or other personal id provided by the customer to verify his/her identity at the point of sale. | ID_RFC_PRSL_ID | Identity | integer | |
AuthorizationMethodCode | Identifies the method used to authorize tender. Examples include by electronic query, by sales employee visual inspection of customer card and id. | LU_MTH_AZN | Code4 | char(4) | |
Track1CreditCardBitMap | Defines the bit pattern used on track 1 of the magnetic strip on the back of a credit card. | DE_TRCK_1_BT_MP | BitMap | binary(128) | |
Track2CreditCardBitMap | Defines the bit pattern used on track 2 of the magnetic strip on the back of a credit card. | DE_TRCK_2_BT_MP | BitMap | binary(128) | |
Track3CreditCardBitMap | Defines the bit pattern used on track 3 of the magnetic strip on the back of a credit card. | DE_TRCK_3_BT | BitMap | binary(128) | |
AdjudicationCode | A code indicating the result of a request to authorize the use of tender to settle a transaction. | LU_ADJN_CRDB | Code6 | char(6) | |
CardExpirationDate | The expiration date of the Credit or Debit card, as taken from the card in MMYY format. | DC_EP_CRD | Code4 | char(4) | |
CardHolderName | The name of the cardholder, as taken from the card. | NM_CRD_HLD | Name | varchar(40) | |
CardIssuerSequenceNumber | The IssueSequnce number of the credit card being used assigned by the Credit/Debit Card issuer. | AI_CRD_ISS | Identity | integer | |
CardStartDate | The commencement date of the Credit or Debit card, as taken from the card in MMYY format. | DT_CRD_SRT | Code4 | char(4) | |
ServiceCode | The value of the service field from the card. In XML this is referred to as a SecurityCode. The names vary from one credit debit card provider to another. Both are the same thing - a 3-4 digit code used to validate a card at the POS. | CD_SV | Code4 | char(4) | |
Track4CreditCardBitMap | Defines the bit pattern used on track 4 of the magnetic strip on the back of a credit card. | BM_CR_CRD_TRK_4 | BitMap | binary(128) | |
ReconciliationCode | A code used to indicate if thie credit/debit card instance is reconciled or not. | CD_RCN | Identity | integer | |